package cn.stylefeng.guns.modular.demo.excel.domain;

import cn.stylefeng.guns.modular.demo.excel.converter.BigDecimalConverter;
import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;

@Data
public class PurchaseExcelData implements Serializable {
    @ExcelProperty(index = 0, value = "序号")
    private String serialNumber;

    @ExcelProperty(index = 1, value = "商品编码")
    private String productCode;

    @ExcelProperty(index = 2, value = "通用名称")
    private String productName;

    @ExcelProperty(index = 3, value = "规格/型号")
    private String specification;

    @ExcelProperty(index = 4, value = "生产厂家")
    private String manufacturer;

    @ExcelProperty(index = 5, value = "单位")
    private String unit;

    @ExcelProperty(index = 6, value = "销售级别")
    private String salesLevel;

    @ExcelProperty(index = 7, value = "备注")
    private String remark;

    @ExcelProperty(index = 8, value = "经营管理类别")
    private String managementCategory;

    @ExcelProperty(index = 9, value = "7天配送量")
    private BigDecimal sevenDaysDelivery;

    @ExcelProperty(index = 10, value = "30天配送量")
    private BigDecimal thirtyDaysDelivery;

    @ExcelProperty(index = 11, value = "30天对外批发量")
    private String thirtyDaysWholesale;

    @ExcelProperty(index = 12, value = "30天门店销售量")
    private BigDecimal thirtyDaysStoreSales;

    @ExcelProperty(index = 13, value = "60天门店销售量")
    private BigDecimal sixtyDaysStoreSales;

    @ExcelProperty(index = 14, value = "90天门店销售量")
    private BigDecimal ninetyDaysStoreSales;

    @ExcelProperty(index = 15, value = "平均月销")
    private BigDecimal averageMonthlySales;

    @ExcelProperty(index = 16, value = "平均月销计划")
    private BigDecimal averageMonthlySalesPlan;

    @ExcelProperty(index = 17, value = "平均配送")
    private BigDecimal averageDelivery;

    @ExcelProperty(index = 18, value = "平均配送计划")
    private BigDecimal averageDeliveryPlan;

    @ExcelProperty(index = 19, value = "最终计划")
    private BigDecimal finalPlan;

    @ExcelProperty(index = 20, value = "计划")
    private String plan;

    @ExcelProperty(index = 21, value = "仓库可用库存")
    private BigDecimal warehouseAvailableStock;

    @ExcelProperty(index = 22, value = "门店库存")
    private BigDecimal storeStock;

    @ExcelProperty(index = 23, value = "采购在途量")
    private String purchaseInTransit;

    @ExcelProperty(index = 24, value = "配送在途量")
    private BigDecimal deliveryInTransit;

    @ExcelProperty(index = 25, value = "已收货未上架")
    private String receivedNotShelved;

    @ExcelProperty(index = 26, value = "末次进价")
    private BigDecimal lastPurchasePrice;

    @ExcelProperty(index = 27, value = "最后进货日期")
    private String lastPurchaseDate;

    @ExcelProperty(index = 28, value = "末次进货供应商编码")
    private String lastPurchaseSupplierCode;

    @ExcelProperty(index = 29, value = "末次进货供应商名称")
    private String lastPurchaseSupplierName;

    @ExcelProperty(index = 30, value = "大包装")
    private Integer largePackage;

    @ExcelProperty(index = 31, value = "60天动销门店数")
    private String storeCount60Days;

    @ExcelProperty(index = 32, value = "库存门店数")
    private String storeCount;

    @ExcelProperty(index = 33, value = "60天对外批发量")
    private String wholesaleVolume60Days;

    @ExcelProperty(index = 34, value = "30天门店请货量")
    private String storeOrderVolume30Days;

    @ExcelProperty(index = 35, value = "仓库可销天数")
    private String warehouseSellableDays;

    @ExcelProperty(index = 36, value = "中包装")
    private String mediumPackage;

    @ExcelProperty(index = 37, value = "末次采购员(供应商)")
    private String lastPurchaseEmployee;

    @ExcelProperty(index = 38, value = "结款方式")
    private String paymentMethod;

    @ExcelProperty(index = 39, value = "商品分类")
    private String productCategory;

    @ExcelProperty(index = 40, value = "采购员")
    private String purchaser;

    @ExcelProperty(index = 41, value = "批准文号")
    private String approvalNumber;

    @ExcelProperty(index = 42, value = "国际条形码")
    private String internationalBarcode;

    @ExcelProperty(index = 43, value = "商品定位")
    private String productPosition;

    @ExcelProperty(index = 44, value = "仓库占用库存")
    private String warehouseOccupiedStock;

    @ExcelProperty(index = 45, value = "国家医保品种编码")
    private String nationalMedicalInsuranceCode;

    @ExcelProperty(index = 46, value = "商品创建日期")
    private String productCreationDate;

    @ExcelProperty(index = 47, value = "仓库库存成本金额")
    private String warehouseStockCostAmount;

    @ExcelProperty(index = 48, value = "总库存成本金额")
    private String totalStockCostAmount;

    @ExcelProperty(index = 49, value = "首次进货日期")
    private String firstPurchaseDate;

    @ExcelProperty(index = 50, value = "国家医保支付价")
    private String nationalMedicalInsurancePrice;

    @ExcelProperty(index = 51, value = "是否国谈品种")
    private String nationalNegotiationVariety;

    @ExcelProperty(index = 52, value = "煎药区库存")
    private String decoctionAreaStock;

    @ExcelProperty(index = 53, value = "最终计划（四舍五入）")
    private BigDecimal finalPlan2;

}
